<template>
  <div class="app-container">
    <el-form
      :model="queryParams"
      ref="queryRef"
      :inline="true"
      v-show="showSearch"
      label-width="68px"
    >
      <el-form-item label="用户名称" prop="userName">
        <el-input
          v-model="queryParams.userName"
          placeholder="请输入用户名称"
          clearable
          style="width: 240px"
          @keyup.enter="handleQuery"
        />
      </el-form-item>
      <el-form-item label="手机号码" prop="phoneNumber">
        <el-input
          v-model="queryParams.phoneNumber"
          placeholder="请输入手机号码"
          clearable
          style="width: 240px"
          @keyup.enter="handleQuery"
        />
      </el-form-item>
      <el-form-item label="店铺名称" prop="shopName">
        <el-input
          v-model="queryParams.shopName"
          placeholder="请输入店铺名称"
          clearable
          style="width: 240px"
          @keyup.enter="handleQuery"
        />
      </el-form-item>
      <el-form-item label="店铺编号" prop="shopNo">
        <el-input
          v-model="queryParams.shopNo"
          placeholder="请输入店铺编号"
          clearable
          style="width: 240px"
          @keyup.enter="handleQuery"
        />
      </el-form-item>
      <el-form-item label="订单编号" prop="orderNo">
        <el-input
          v-model="queryParams.orderNo"
          placeholder="请输入订单编号"
          clearable
          style="width: 240px"
          @keyup.enter="handleQuery"
        />
      </el-form-item>
      <el-form-item label="套餐名称" prop="packageName">
        <el-input
          v-model="queryParams.packageName"
          placeholder="请输入套餐名"
          clearable
          style="width: 240px"
          @keyup.enter="handleQuery"
        />
      </el-form-item>
      <el-form-item label="导入时间" prop="date">
        <el-date-picker
          v-model="dateRange"
          type="daterange"
          unlink-panels
          value-format="YYYY-MM-DD"
          format="YYYY-MM-DD"
          range-separator="至"
          start-placeholder="开始日期"
          end-placeholder="结束日期"
          :shortcuts="shortcuts"
          @change="changeDate"
        />
      </el-form-item>
      <el-form-item label="订单创建时间（达成）" label-width="160" prop="date1">
        <el-date-picker
          v-model="dateRange1"
          type="daterange"
          unlink-panels
          value-format="YYYY-MM-DD"
          format="YYYY-MM-DD"
          range-separator="至"
          start-placeholder="开始日期"
          end-placeholder="结束日期"
          :shortcuts="shortcuts"
          :size="size"
          @change="changeDate1"
        />
      </el-form-item>
      <el-form-item>
        <el-button type="primary" icon="Search" @click="handleQuery"
          >搜索</el-button
        >
        <el-button icon="Refresh" @click="resetQuery">重置</el-button>
      </el-form-item>
    </el-form>

    <el-row :gutter="10" class="mb8">
      <!-- <el-col :span="1.5">
        <el-button
          type="primary"
          plain
          icon="Plus"
          @click="handleAdd"
          v-hasPermi="['phoneBill:excel:add']"
          >新增</el-button
        >
      </el-col> -->
      <!-- <el-col :span="1.5">
        <el-button
          type="success"
          plain
          icon="Edit"
          :disabled="single"
          @click="handleUpdate"
          v-hasPermi="['phoneBill:excel:edit']"
          >修改</el-button
        >
      </el-col> -->
      <el-col :span="1.5">
        <el-button
          type="danger"
          plain
          icon="Delete"
          :disabled="multiple"
          @click="handleDelete"
          v-hasPermi="['phoneBill:excel:remove']"
          >删除</el-button
        >
      </el-col>
      <el-col :span="1.5">
        <el-button
          type="info"
          plain
          icon="Upload"
          @click="handleImport"
          v-hasPermi="['phoneBill:excel:upload']"
          >导入</el-button
        >
      </el-col>
      <el-col :span="1.5">
        <el-button
          type="warning"
          plain
          icon="Download"
          @click="handleExport"
          v-hasPermi="['phoneBill:excel:export']"
          >导出</el-button
        >
      </el-col>
      <right-toolbar
        v-model:showSearch="showSearch"
        @queryTable="getList"
        :columns="columns"
      ></right-toolbar>
    </el-row>

    <el-table
      v-loading="loading"
      :data="userList"
      @selection-change="handleSelectionChange"
      v-horizontal-scroll="'always'"
      border
    >
      <el-table-column type="selection" width="40" align="center" />
      <el-table-column
        label="ID"
        align="center"
        key="id"
        prop="id"
        v-if="columns[10].visible"
        :show-overflow-tooltip="true"
        width="80"
      />
      <el-table-column
        label="导入时间"
        align="center"
        key="createTime"
        prop="createTime"
        v-if="columns[0].visible"
      >
        <template #default="scope">
          <span>{{ parseTime(scope.row.createTime) }}</span>
        </template>
      </el-table-column>
      <el-table-column
        label="导入人名称"
        align="center"
        key="createName"
        prop="createName"
        width="100"
      />
      <el-table-column
        label="更新时间"
        align="center"
        key="loadingTime"
        prop="loadingTime"
      >
        <template #default="scope">
          <span>{{ parseTime(scope.row.loadingTime) }}</span>
        </template>
      </el-table-column>
      <el-table-column
        label="套餐名称"
        align="center"
        key="packageName"
        prop="packageName"
        v-if="columns[1].visible"
        width="100"
        :show-overflow-tooltip="true"
      />

      <el-table-column
        label="订单编号"
        align="center"
        key="orderNo"
        prop="orderNo"
        v-if="columns[2].visible"
        width="100"
      />
      <el-table-column
        label="订单外部ID"
        align="center"
        key="var1"
        prop="var1"
        v-if="columns[11].visible"
        width="100"
      />
      <el-table-column
        label="店铺名称"
        align="center"
        key="shopName"
        prop="shopName"
        v-if="columns[3].visible"
        width="100"
      />
      <el-table-column
        label="店铺编号"
        align="center"
        key="shopNo"
        prop="shopNo"
        v-if="columns[4].visible"
        width="80"
      />
      <el-table-column
        label="手机号码"
        align="center"
        key="phoneNumber"
        prop="phoneNumber"
        v-if="columns[5].visible"
        width="100"
      />

      <el-table-column
        label="用户名称"
        align="center"
        key="userName"
        prop="userName"
        v-if="columns[6].visible"
        width="80"
      />
      <el-table-column label="状态" align="center" key="status" prop="status">
        <template #default="scope">
          <span v-if="scope.row.status == 0">可领取</span>
          <span v-if="scope.row.status == 1">不可领取</span>
        </template>
      </el-table-column>
      <el-table-column
        label="第1阶段开始时间"
        align="center"
        key="receiveStartTime"
        prop="receiveStartTime"
        v-if="columns[7].visible"
      />
      <el-table-column
        label="第1阶段结束时间"
        align="center"
        key="receiveEndTime"
        prop="receiveEndTime"
        v-if="columns[8].visible"
      />
      <el-table-column
        label="第1阶段领取金额"
        align="center"
        key="onceAmount"
        prop="onceAmount"
        v-if="columns[9].visible"
        width="60"
      />
      <el-table-column
        label="第1阶段领取次数"
        align="center"
        key="onceNum"
        prop="onceNum"
        v-if="columns[10].visible"
        width="60"
      />
      <el-table-column
        label="第1阶段链接类型"
        align="center"
        key="lineType"
        prop="lineType"
        v-if="columns[11].visible"
        width="60"
      />
      <el-table-column
        label="第2阶段开始时间"
        align="center"
        key="twoStartTime"
        prop="twoStartTime"
      />
      <el-table-column
        label="第2阶段结束时间"
        align="center"
        key="twoEndTime"
        prop="twoEndTime"
      />
      <el-table-column
        label="第2阶段领取金额"
        align="center"
        key="twoAmount"
        prop="twoAmount"
        v-if="columns[12].visible"
        width="60"
      />
      <el-table-column
        label="第2阶段领取次数"
        align="center"
        key="twoNum"
        prop="twoNum"
        v-if="columns[13].visible"
        width="60"
      />
      <el-table-column
        label="第2阶段链接类型"
        align="center"
        key="twoLineType"
        prop="twoLineType"
        v-if="columns[14].visible"
        width="60"
      />
      <el-table-column
        label="第3阶段开始时间"
        align="center"
        key="threeStartTime"
        prop="threeStartTime"
      />
      <el-table-column
        label="第3阶段结束时间"
        align="center"
        key="threeEndTime"
        prop="threeEndTime"
      />
      <el-table-column
        label="第3阶段领取金额"
        align="center"
        key="threeAmount"
        prop="threeAmount"
        v-if="columns[15].visible"
        width="60"
      />
      <el-table-column
        label="第3阶段领取次数"
        align="center"
        key="threeNum"
        prop="threeNum"
        v-if="columns[16].visible"
        width="60"
      />
      <el-table-column
        label="第3阶段链接类型"
        align="center"
        key="threeLineType"
        prop="threeLineType"
        v-if="columns[17].visible"
        width="60"
      />
      <el-table-column
        label="第4阶段开始时间"
        align="center"
        key="fourStartTime"
        prop="fourStartTime"
      />
      <el-table-column
        label="第4阶段结束时间"
        align="center"
        key="fourEndTime"
        prop="fourEndTime"
      />
      <el-table-column
        label="第4阶段领取金额"
        align="center"
        key="fourAmount"
        prop="fourAmount"
        width="60"
      />
      <el-table-column
        label="第4阶段链接类型"
        align="center"
        key="fourLineType"
        prop="fourLineType"
        width="60"
      />
      <el-table-column
        label="第5阶段开始时间"
        align="center"
        key="fiveStartTime"
        prop="fiveStartTime"
      />
      <el-table-column
        label="第5阶段结束时间"
        align="center"
        key="fiveEndTime"
        prop="fiveEndTime"
      />
      <el-table-column
        label="第5阶段领取金额"
        align="center"
        key="fiveAmount"
        prop="fiveAmount"
        width="60"
      />
      <el-table-column
        label="第5阶段链接类型"
        align="center"
        key="fiveLineType"
        prop="fiveLineType"
        width="60"
      />
      <el-table-column
        label="第6阶段开始时间"
        align="center"
        key="sixStartTime"
        prop="sixStartTime"
      />
      <el-table-column
        label="第6阶段结束时间"
        align="center"
        key="sixEndTime"
        prop="sixEndTime"
      />
      <el-table-column
        label="第6阶段领取金额"
        align="center"
        key="sixAmount"
        prop="sixAmount"
        width="60"
      />
      <el-table-column
        label="第6阶段链接类型"
        align="center"
        key="sixLineType"
        prop="sixLineType"
        width="60"
      />
      <el-table-column
        label="操作"
        align="center"
        width="100"
        class-name="small-padding fixed-width"
      >
        <template #default="scope">
          <!-- <el-tooltip
            content="修改"
            placement="top"
            v-if="scope.row.userId !== 1"
          >
            <el-button
              link
              type="primary"
              icon="Edit"
              @click="handleUpdate(scope.row)"
              v-hasPermi="['phoneBill:excel:edit']"
            ></el-button>
          </el-tooltip> -->
          <el-tooltip
            content="删除"
            placement="top"
            v-if="scope.row.userId !== 1"
          >
            <el-button
              link
              type="primary"
              icon="Delete"
              @click="handleDelete(scope.row)"
              v-hasPermi="['phoneBill:excel:remove']"
            ></el-button>
          </el-tooltip>
        </template>
      </el-table-column>
    </el-table>
    <pagination
      v-show="total > 0"
      :total="total"
      v-model:page="queryParams.pageNum"
      v-model:limit="queryParams.pageSize"
      @pagination="getList"
    />

    <!-- 用户导入对话框 -->
    <el-dialog
      :title="upload.title"
      v-model="upload.open"
      width="400px"
      append-to-body
    >
      <el-upload
        ref="uploadRef"
        :limit="1"
        accept=".xlsx, .xls"
        :headers="upload.headers"
        :action="upload.url + '?updateSupport=' + upload.updateSupport"
        :disabled="upload.isUploading"
        :on-progress="handleFileUploadProgress"
        :on-success="handleFileSuccess"
        :auto-upload="false"
        drag
      >
        <el-icon class="el-icon--upload"><upload-filled /></el-icon>
        <div class="el-upload__text">将文件拖到此处，或<em>点击上传</em></div>
        <template #tip>
          <div class="el-upload__tip text-center">
            <div class="el-upload__tip">
              <el-checkbox
                v-model="upload.updateSupport"
              />是否更新已经存在的数据
            </div>
            <span>仅允许导入xls、xlsx格式文件。</span>
            <el-link
              type="primary"
              :underline="false"
              style="font-size: 12px; vertical-align: baseline"
              @click="importTemplate(2)"
              >下载模板</el-link
            >
            <span style="margin-right: 10px"></span>
            <!-- <el-link type="primary" :underline="false" style="font-size: 12px; vertical-align: baseline"
              @click="importTemplate(1)">下载旧模板</el-link> -->
          </div>
        </template>
      </el-upload>
      <template #footer>
        <div class="dialog-footer">
          <el-button type="primary" @click="submitFileForm">确 定</el-button>
          <el-button @click="upload.open = false">取 消</el-button>
        </div>
      </template>
    </el-dialog>
  </div>
</template>

<script setup name="Excel">
import { getToken } from "@/utils/auth";
import { listExcel } from "@/api/phoneBill/excel";
import { delExcelInfo } from "@/api/phoneBill/excel";
import { parseTime } from "@/utils/ruoyi.js";
import { shortcuts, Y, M, D } from "@/utils/dateSet";
const { proxy } = getCurrentInstance();

const userList = ref([]);
const open = ref(false);
const loading = ref(true);
const showSearch = ref(true);
const ids = ref([]);
const single = ref(true);
const multiple = ref(true);
const total = ref(0);
const title = ref("");
// const dateRange = ref([]);
const dateRange = ref([
  parseTime(
    new Date(Y.value, M.value, D.value, 0, 0, 0).getTime() -
      3600 * 1000 * 24 * 30
  ),
  parseTime(new Date(Y.value, M.value, D.value, 23, 59, 59).getTime()),
]);
const dateRange1 = ref([]);
/*** 用户导入参数 */
const upload = reactive({
  // 是否显示弹出层（用户导入）
  open: false,
  // 弹出层标题（用户导入）
  title: "",
  // 是否禁用上传
  isUploading: false,
  // 是否更新已经存在的用户数据
  updateSupport: 0,
  // 设置上传的请求头部
  headers: { Authorization: "Bearer " + getToken() },
  // 上传的地址
  url: import.meta.env.VITE_APP_BASE_API + "/system/info/uploadExcel",
});
// 列显隐信息
const columns = ref([
  { key: 10, label: `ID`, visible: true },
  { key: 0, label: `导入时间`, visible: true },
  { key: 1, label: `套餐名称`, visible: true },
  { key: 2, label: `订单编号`, visible: true },
  { key: 11, label: `订单外部ID`, visible: true },
  { key: 3, label: `店铺名称`, visible: true },
  { key: 4, label: `店铺编号`, visible: true },
  { key: 5, label: `手机号码`, visible: true },
  { key: 6, label: `用户名称`, visible: true },
  { key: 7, label: `第1阶段开始时间`, visible: true },
  { key: 8, label: `第1阶段结束时间`, visible: true },
  { key: 9, label: `第1阶段领取金额`, visible: true },
  { key: 10, label: `第1阶段领取次数`, visible: true },
  { key: 11, label: `第1阶段链接类型`, visible: true },
  { key: 12, label: `第2阶段领取金额`, visible: true },
  { key: 13, label: `第2阶段领取次数`, visible: true },
  { key: 14, label: `第2阶段链接类型`, visible: true },
  { key: 15, label: `第3阶段领取金额`, visible: true },
  { key: 16, label: `第3阶段领取次数`, visible: true },
  { key: 17, label: `第3阶段链接类型`, visible: true },
]);

const data = reactive({
  form: {},
  queryParams: {
    pageNum: 1,
    pageSize: 10,
    userName: undefined,
    phoneNumber: undefined,
    status: undefined,
    deptId: undefined,
  },
  rules: {
    userName: [
      { required: true, message: "用户名称不能为空", trigger: "blur" },
      {
        min: 2,
        max: 20,
        message: "用户名称长度必须介于 2 和 20 之间",
        trigger: "blur",
      },
    ],
    nickName: [
      { required: true, message: "用户昵称不能为空", trigger: "blur" },
    ],
    password: [
      { required: true, message: "用户密码不能为空", trigger: "blur" },
      {
        min: 5,
        max: 20,
        message: "用户密码长度必须介于 5 和 20 之间",
        trigger: "blur",
      },
    ],
    email: [
      {
        type: "email",
        message: "请输入正确的邮箱地址",
        trigger: ["blur", "change"],
      },
    ],
    phonenumber: [
      {
        pattern: /^1[3|4|5|6|7|8|9][0-9]\d{8}$/,
        message: "请输入正确的手机号码",
        trigger: "blur",
      },
    ],
  },
});

const { queryParams, form, rules } = toRefs(data);
const changeDate = (val) => {
  if (!val) {
    dateRange.value = [];
  } else {
    queryParams.value.start = dateRange.value[0];
    queryParams.value.end = dateRange.value[1];
  }
};
const changeDate1 = (val) => {
  if (!val) {
    dateRange1.value = [];
  } else {
    queryParams.value.orderStart = dateRange1.value[0];
    queryParams.value.orderEnd = dateRange1.value[1];
  }
};
/** 查询用户列表 */
function getList() {
  loading.value = true;
  listExcel(
    proxy.addDateRange({
      ...queryParams.value,
      start: dateRange.value ? dateRange.value[0] : "",
      end: dateRange.value ? dateRange.value[1] : "",
      orderStart: dateRange1.value ? dateRange1.value[0] : "",
      orderEnd: dateRange1.value ? dateRange1.value[1] : "",
    })
  ).then((res) => {
    loading.value = false;
    userList.value = res.rows;
    total.value = res.total;
  });
}

/** 搜索按钮操作 */
function handleQuery() {
  queryParams.value.pageNum = 1;
  getList();
}
/** 重置按钮操作 */
function resetQuery() {
  dateRange.value = [
    parseTime(
      new Date(Y.value, M.value, D.value, 0, 0, 0).getTime() -
        3600 * 1000 * 24 * 30
    ),
    parseTime(new Date(Y.value, M.value, D.value, 23, 59, 59).getTime()),
  ];
  dateRange1.value = [];
  proxy.resetForm("queryRef");
  queryParams.value.deptId = undefined;
  queryParams.value.start = dateRange.value[0];
  queryParams.value.end = dateRange.value[1];
  queryParams.value.orderStart = "";
  queryParams.value.orderEnd = "";
  // proxy.$refs.deptTreeRef.setCurrentKey(null);
  handleQuery();
}
/** 删除按钮操作 */
function handleDelete(row) {
  const excelIds = row.id || ids.value;
  proxy.$modal
    .confirm('是否确认删除编号为"' + excelIds + '"的数据项？')
    .then(function () {
      return delExcelInfo(excelIds);
    })
    .then(() => {
      getList();
      proxy.$modal.msgSuccess("删除成功");
    })
    .catch(() => {});
}
/** 导出按钮操作 */
function handleExport() {
  proxy.download(
    "system/info/export",
    {
      ...queryParams.value,
      start: dateRange.value ? dateRange.value[0] : "",
      end: dateRange.value ? dateRange.value[1] : "",
    },
    `话费领取信息记录对比-${new Date().getTime()}.xlsx`
  );
}

/** 选择条数  */
function handleSelectionChange(selection) {
  ids.value = selection.map((item) => item.id);
  single.value = selection.length != 1;
  multiple.value = !selection.length;
}
/** 导入按钮操作 */
function handleImport() {
  upload.title = "用户导入";
  upload.open = true;
}
/** 下载模板操作 */
function importTemplate(t) {
  proxy.download(
    `/system/info/exportTemplate/${t}`,
    {},
    `话费领取信息-${new Date().getTime()}.xlsx`
  );
}
/**文件上传中处理 */
const handleFileUploadProgress = (event, file, fileList) => {
  upload.isUploading = true;
};
/** 文件上传成功处理 */
const handleFileSuccess = (response, file, fileList) => {
  upload.open = false;
  upload.isUploading = false;
  proxy.$refs["uploadRef"].handleRemove(file);
  if (response.data.have.length || response.data.error.length) {
    proxy.$alert(
      `<div style='overflow: auto;overflow-x: hidden;max-height: 70vh;padding: 10px 20px 0;'>
      已更新：<div class='el-textarea'><textarea cols='40' rows='5' class="el-textarea__inner">${response.data.have} </textarea></div>
      导入失败：<div class='el-textarea'><textarea cols='40' rows='5' class="el-textarea__inner">${response.data.error} </textarea></div>
      </div>`,
      "导入结果",
      { dangerouslyUseHTMLString: true }
    );
  } else {
    proxy.$alert(
      "<div style='overflow: auto;overflow-x: hidden;max-height: 70vh;padding: 10px 20px 0;'>" +
        response.msg +
        "</div>",
      "导入结果",
      { dangerouslyUseHTMLString: true }
    );
  }

  getList();
};
/** 提交上传文件 */
function submitFileForm() {
  proxy.$refs["uploadRef"].submit();
}
/** 重置操作表单 */
function reset() {
  form.value = {
    userId: undefined,
    deptId: undefined,
    userName: undefined,
    nickName: undefined,
    password: undefined,
    phonenumber: undefined,
    email: undefined,
    sex: undefined,
    status: "0",
    remark: undefined,
    postIds: [],
    roleIds: [],
  };
  proxy.resetForm("userRef");
}
/** 取消按钮 */
function cancel() {
  open.value = false;
  reset();
}
/** 新增按钮操作 */
// function handleAdd() {
//   reset();
//   getUser().then((response) => {
//     postOptions.value = response.posts;
//     roleOptions.value = response.roles;
//     open.value = true;
//     title.value = "添加用户";
//     form.value.password = initPassword.value;
//   });
// }
/** 修改按钮操作 */
// function handleUpdate(row) {
//   reset();
//   const userId = row.userId || ids.value;
//   getUser(userId).then((response) => {
//     form.value = response.data;
//     postOptions.value = response.posts;
//     roleOptions.value = response.roles;
//     form.value.postIds = response.postIds;
//     form.value.roleIds = response.roleIds;
//     open.value = true;
//     title.value = "修改";
//     form.password = "";
//   });
// }
/** 提交按钮 */
function submitForm() {
  proxy.$refs["userRef"].validate((valid) => {
    if (valid) {
      if (form.value.userId != undefined) {
        updateUser(form.value).then((response) => {
          proxy.$modal.msgSuccess("修改成功");
          open.value = false;
          getList();
        });
      } else {
        addUser(form.value).then((response) => {
          proxy.$modal.msgSuccess("新增成功");
          open.value = false;
          getList();
        });
      }
    }
  });
}

getList();
</script>
